Opening tables
Short Description
The thread is trying to open a table.
Detailed Description​
The thread is trying to open a table. This should be a very fast procedure, unless something prevents opening. For example, an ALTER TABLE or a LOCK TABLE statement can prevent opening a table until the statement is finished. It is also worth checking that your table_open_cache value is large enough.
This is a regular table open call. System tables will have a wait state of Opening system tables.
How to reduce this wait​
Not available yet. Contributions welcome.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.